In SAS® Merchandise Allocation, Flood to Children might not work as expected when certain merchandise members are changed in Allocation Attributes.  There are several circumstances that might cause this behavior:

1. When the Location Version is Null, the following error might occur in the IMPORT_LOG table:
   ORA-01747: invalid user.table.column, table.column, or column specification (p_flood_to_children (11,1,1,2,ATTR_M,,-1,-1,NULL), SQL#:7500
2. Changes to the Base Data, Plan floods the IDs but might not flood the ‘Name’ as expected.  This scenario results in a display issue.  In some cases the following error occurs when you open the worksheet:
   Error Code: 1003  -  Error executing stored procedure maxdata.p_compose_query. Native Error 20001 [IMPS][ODBC Oracle Wire Protocol driver][Oracle]ORA-20001: ORA-20001: ORA-20001: No TIME_IDs found in T_CUBE_TIME table for CUBE_ID=11698093 (, SQL#:) (p_compose_query (ALLOC_PLAN,11698093,-1,-1,MPLAN,-1,-1,-1,-1,-1,OUT out_dml,out_join,out_where,out_option,out_future1 ), SQL#:6000) ORA-06512: at  MAXDATA.P_COMPOSE_QUERY , line 274 ORA-06512: at line 1)]

3. Changes to the Base Data, SKU Attribute floods the IDs, but might not flood the ‘Name’ as expected.  This scenario results in a display issue.

There are no workarounds for these issues. 

Operating System and Release Information